library(RODBC)
#create a connection to MVD
MVD = odbcDriverConnect('Driver={Microsoft Access Driver (*.mdb)};Dbq=\\\\Zl5570-jeremy\\MVD_Database\\MVD.mdb;SystemDB=\\\\Zl5570-jeremy\\MVD_Database\\Security.mdw;Uid=ctbcc;Pwd=admin;')
  #extract a query
  t.query = "SELECT Georeference.point_ID, GEO_DATA.east, GEO_DATA.north, GEO_DATA.zone, GEO_DATA.Subregion FROM GEO_DATA INNER JOIN Georeference ON (GEO_DATA.zone = Georeference.zone) AND (GEO_DATA.north = Georeference.north) AND (GEO_DATA.east = Georeference.east) WHERE (((GEO_DATA.Subregion)='su'));"
  t.data = sqlQuery(MVD,t.query)

#close the connection to MVD
odbcClose(MVD)